﻿CREATE TABLE [dbo].[JobInCategory] (
    [JobId]         UNIQUEIDENTIFIER NOT NULL,
    [JobCategoryId] UNIQUEIDENTIFIER NOT NULL,
    CONSTRAINT [PK_JobInCategory] PRIMARY KEY CLUSTERED ([JobId] ASC, [JobCategoryId] ASC),
    CONSTRAINT [FK_JobInCategory_Job] FOREIGN KEY ([JobId]) REFERENCES [dbo].[Job] ([JobId]),
    CONSTRAINT [FK_JobInCategory_JobCategory] FOREIGN KEY ([JobCategoryId]) REFERENCES [dbo].[JobCategory] ([JobCategoryId])
);

